TMyServerControl Methods

Name	Description
AddWhere (inherited from TCustomDADataSet)	Adds condition to the WHERE clause of SELECT statement in the SQL property.
AnalyzeTable	Analyzes and stores the key distribution for the table
ApplyRange (inherited from TMemDataSet)	Applies a range to the dataset.
ApplyUpdates (inherited from TMemDataSet)	Overloaded. Writes dataset's pending cached updates to a database.
BreakExec (inherited from TCustomDADataSet)	Breaks execution of the SQL statement on the server.
CancelRange (inherited from TMemDataSet)	Removes any ranges currently in effect for a dataset.
CancelUpdates (inherited from TMemDataSet)	Clears all pending cached updates from cache and restores dataset in its prior state.
CheckTable	Checks MyISAM and InnoDB tables for failures.
CommitUpdates (inherited from TMemDataSet)	Clears the cached updates buffer.
CreateBlobStream (inherited from TCustomDADataSet)	Used to obtain a stream for reading data from or writing data to a BLOB field, specified by the Field parameter.
CreateDatabase	Creates a new database with the specified name.
DeferredPost (inherited from TMemDataSet)	Makes permanent changes to the database server.
DeleteWhere (inherited from TCustomDADataSet)	Removes WHERE clause from the SQL property and assigns the BaseSQL property.
DropDatabase	Drops the specified database.
EditRangeEnd (inherited from TMemDataSet)	Enables changing the ending value for an existing range.
EditRangeStart (inherited from TMemDataSet)	Enables changing the starting value for an existing range.
Execute (inherited from TCustomDADataSet)	Overloaded. Executes a SQL statement on the server.
Executing (inherited from TCustomDADataSet)	Indicates whether SQL statement is still being executed.
Fetched (inherited from TCustomDADataSet)	Used to find out whether TCustomDADataSet has fetched all rows.
Fetching (inherited from TCustomDADataSet)	Used to learn whether TCustomDADataSet is still fetching rows.
FetchingAll (inherited from TCustomDADataSet)	Used to learn whether TCustomDADataSet is fetching all rows to the end.
FindKey (inherited from TCustomDADataSet)	Searches for a record which contains specified field values.
FindMacro (inherited from TCustomDADataSet)	Finds a macro with the specified name.
FindNearest (inherited from TCustomDADataSet)	Moves the cursor to a specific record or to the first record in the dataset that matches or is greater than the values specified in the KeyValues parameter.
FindParam (inherited from TCustomDADataSet)	Determines if a parameter with the specified name exists in a dataset.
Flush	Flushes server data from the memory to disk.
GetBlob (inherited from TMemDataSet)	Overloaded. Retrieves TBlob object for a field or current record when only its name or the field itself is known.
GetDataType (inherited from TCustomDADataSet)	Returns internal field types defined in the MemData and accompanying modules.
GetFieldEnum (inherited from TCustomMyDataSet)	Retrieve the list of acceptable values for a specified field given by the FieldName parameter.
GetFieldObject (inherited from TCustomDADataSet)	Returns a multireference shared object from field.
GetFieldPrecision (inherited from TCustomDADataSet)	Retrieves the precision of a number field.
GetFieldScale (inherited from TCustomDADataSet)	Retrieves the scale of a number field.
GetKeyFieldNames (inherited from TCustomDADataSet)	Provides a list of available key field names.
GetOrderBy (inherited from TCustomDADataSet)	Retrieves an ORDER BY clause from a SQL statement.
GetServiceNames	Populates a list of MySQL services at the server to which Connection is connected.
GotoCurrent (inherited from TCustomDADataSet)	Sets the current record in this dataset similar to the current record in another dataset.
KillProcess	Breaks the execution of the specified process.
Locate (inherited from TMemDataSet)	Overloaded. Searches a dataset for a specific record and positions the cursor on it.
LocateEx (inherited from TMemDataSet)	Overloaded. Excludes features that don't need to be included to the TMemDataSet.Locate method of TDataSet.
Lock (inherited from TCustomMyDataSet)	Overloaded. Locks the current record for the current connection.
LockTable (inherited from TCustomMyDataSet)	Locks table for the current connection.
MacroByName (inherited from TCustomDADataSet)	Finds a macro with the specified name.
OpenNext (inherited from TCustomMyDataSet)	Opens next rowset in the statement.
OptimizeTable	Packs tables deleting unused places from the file at the disk and defragmenting it.
ParamByName (inherited from TCustomDADataSet)	Sets or uses parameter information for a specific parameter based on its name.
Prepare (inherited from TCustomDADataSet)	Allocates, opens, and parses cursor for a query.
RefreshQuick (inherited from TCustomMyDataSet)	Retrieves changes posted to the server by another clients on the client side quickly.
RefreshRecord (inherited from TCustomDADataSet)	Actualizes field values for the current record.
RepairTable	Repairs specified tables.
RestoreSQL (inherited from TCustomDADataSet)	Restores the SQL property modified by AddWhere and SetOrderBy.
RestoreUpdates (inherited from TMemDataSet)	Marks all records in the cache of updates as unapplied.
RevertRecord (inherited from TMemDataSet)	Cancels changes made to the current record when cached updates are enabled.
SaveSQL (inherited from TCustomDADataSet)	Saves the SQL property value to BaseSQL.
SaveToXML (inherited from TMemDataSet)	Overloaded. Saves the current dataset data to a file or a stream in the XML format compatible with ADO format.
ServiceStart	Starts the specified service at the server to which Connection is connected.
ServiceStatus	Returns a status of the specified service at the server to which Connection is connected.
ServiceStop	Stops the specified service at the server to which Connection is connected.
SetOrderBy (inherited from TCustomDADataSet)	Builds an ORDER BY clause of a SELECT statement.
SetRange (inherited from TMemDataSet)	Sets the starting and ending values of a range, and applies it.
SetRangeEnd (inherited from TMemDataSet)	Indicates that subsequent assignments to field values specify the end of the range of rows to include in the dataset.
SetRangeStart (inherited from TMemDataSet)	Indicates that subsequent assignments to field values specify the start of the range of rows to include in the dataset.
ShowProcessList	Shows the list of the processes.
ShowStatus	Shows the current state of the server.
ShowVariables	Shows the values of some MySQL system variables that are in effect for the current connection.
SQLSaved (inherited from TCustomDADataSet)	Determines if the SQL property value was saved to the BaseSQL property.
UnLock (inherited from TCustomDADataSet)	Releases a record lock.
UnLockTable (inherited from TCustomMyDataSet)	Releases a table locked by the TCustomMyDataSet.LockTable method.
UnPrepare (inherited from TMemDataSet)	Frees the resources allocated for a previously prepared query on the server and client sides.
UpdateResult (inherited from TMemDataSet)	Reads the status of the latest call to the ApplyUpdates method while cached updates are enabled.
UpdateStatus (inherited from TMemDataSet)	Indicates the current update status for the dataset when cached updates are enabled.

Name

Description

AddWhere (inherited from TCustomDADataSet)

Adds condition to the WHERE clause of SELECT statement in the SQL property.

AnalyzeTable

Analyzes and stores the key distribution for the table

ApplyRange (inherited from TMemDataSet)

Applies a range to the dataset.

ApplyUpdates (inherited from TMemDataSet)

Overloaded.

Writes dataset's pending cached updates to a database.

BreakExec (inherited from TCustomDADataSet)

Breaks execution of the SQL statement on the server.

CancelRange (inherited from TMemDataSet)

Removes any ranges currently in effect for a dataset.

CancelUpdates (inherited from TMemDataSet)

Clears all pending cached updates from cache and restores dataset in its prior state.

CheckTable

Checks MyISAM and InnoDB tables for failures.

CommitUpdates (inherited from TMemDataSet)

Clears the cached updates buffer.

CreateBlobStream (inherited from TCustomDADataSet)

Used to obtain a stream for reading data from or writing data to a BLOB field, specified by the Field parameter.

CreateDatabase

Creates a new database with the specified name.

DeferredPost (inherited from TMemDataSet)

Makes permanent changes to the database server.

DeleteWhere (inherited from TCustomDADataSet)

Removes WHERE clause from the SQL property and assigns the BaseSQL property.

DropDatabase

Drops the specified database.

EditRangeEnd (inherited from TMemDataSet)

Enables changing the ending value for an existing range.

EditRangeStart (inherited from TMemDataSet)

Enables changing the starting value for an existing range.

Execute (inherited from TCustomDADataSet)

Overloaded.

Executes a SQL statement on the server.

Executing (inherited from TCustomDADataSet)

Indicates whether SQL statement is still being executed.

Fetched (inherited from TCustomDADataSet)

Used to find out whether TCustomDADataSet has fetched all rows.

Fetching (inherited from TCustomDADataSet)

Used to learn whether TCustomDADataSet is still fetching rows.

FetchingAll (inherited from TCustomDADataSet)

Used to learn whether TCustomDADataSet is fetching all rows to the end.

FindKey (inherited from TCustomDADataSet)

Searches for a record which contains specified field values.

FindMacro (inherited from TCustomDADataSet)

Finds a macro with the specified name.

FindNearest (inherited from TCustomDADataSet)

Moves the cursor to a specific record or to the first record in the dataset that matches or is greater than the values specified in the KeyValues parameter.

FindParam (inherited from TCustomDADataSet)

Determines if a parameter with the specified name exists in a dataset.

Flush

Flushes server data from the memory to disk.

GetBlob (inherited from TMemDataSet)

Overloaded.

Retrieves TBlob object for a field or current record when only its name or the field itself is known.

GetDataType (inherited from TCustomDADataSet)

Returns internal field types defined in the MemData and accompanying modules.

GetFieldEnum (inherited from TCustomMyDataSet)

Retrieve the list of acceptable values for a specified field given by the FieldName parameter.

GetFieldObject (inherited from TCustomDADataSet)

Returns a multireference shared object from field.

GetFieldPrecision (inherited from TCustomDADataSet)

Retrieves the precision of a number field.

GetFieldScale (inherited from TCustomDADataSet)

Retrieves the scale of a number field.

GetKeyFieldNames (inherited from TCustomDADataSet)

Provides a list of available key field names.

GetOrderBy (inherited from TCustomDADataSet)

Retrieves an ORDER BY clause from a SQL statement.

GetServiceNames

Populates a list of MySQL services at the server to which Connection is connected.

GotoCurrent (inherited from TCustomDADataSet)

Sets the current record in this dataset similar to the current record in another dataset.

KillProcess

Breaks the execution of the specified process.

Locate (inherited from TMemDataSet)

Overloaded.

Searches a dataset for a specific record and positions the cursor on it.

LocateEx (inherited from TMemDataSet)

Overloaded.

Excludes features that don't need to be included to the TMemDataSet.Locate method of TDataSet.

Lock (inherited from TCustomMyDataSet)

Overloaded.

Locks the current record for the current connection.

LockTable (inherited from TCustomMyDataSet)

Locks table for the current connection.

MacroByName (inherited from TCustomDADataSet)

Finds a macro with the specified name.

OpenNext (inherited from TCustomMyDataSet)

Opens next rowset in the statement.

OptimizeTable

Packs tables deleting unused places from the file at the disk and defragmenting it.

ParamByName (inherited from TCustomDADataSet)

Sets or uses parameter information for a specific parameter based on its name.

Prepare (inherited from TCustomDADataSet)

Allocates, opens, and parses cursor for a query.

RefreshQuick (inherited from TCustomMyDataSet)

Retrieves changes posted to the server by another clients on the client side quickly.

RefreshRecord (inherited from TCustomDADataSet)

Actualizes field values for the current record.

RepairTable

Repairs specified tables.

RestoreSQL (inherited from TCustomDADataSet)

Restores the SQL property modified by AddWhere and SetOrderBy.

RestoreUpdates (inherited from TMemDataSet)

Marks all records in the cache of updates as unapplied.

RevertRecord (inherited from TMemDataSet)

Cancels changes made to the current record when cached updates are enabled.

SaveSQL (inherited from TCustomDADataSet)

Saves the SQL property value to BaseSQL.

SaveToXML (inherited from TMemDataSet)

Overloaded.

Saves the current dataset data to a file or a stream in the XML format compatible with ADO format.

ServiceStart

Starts the specified service at the server to which Connection is connected.

ServiceStatus

Returns a status of the specified service at the server to which Connection is connected.

ServiceStop

Stops the specified service at the server to which Connection is connected.

SetOrderBy (inherited from TCustomDADataSet)

Builds an ORDER BY clause of a SELECT statement.

SetRange (inherited from TMemDataSet)

Sets the starting and ending values of a range, and applies it.

SetRangeEnd (inherited from TMemDataSet)

Indicates that subsequent assignments to field values specify the end of the range of rows to include in the dataset.

SetRangeStart (inherited from TMemDataSet)

Indicates that subsequent assignments to field values specify the start of the range of rows to include in the dataset.

ShowProcessList

Shows the list of the processes.

ShowStatus

Shows the current state of the server.

ShowVariables

Shows the values of some MySQL system variables that are in effect for the current connection.

SQLSaved (inherited from TCustomDADataSet)

Determines if the SQL property value was saved to the BaseSQL property.

UnLock (inherited from TCustomDADataSet)

Releases a record lock.

UnLockTable (inherited from TCustomMyDataSet)

Releases a table locked by the TCustomMyDataSet.LockTable method.

UnPrepare (inherited from TMemDataSet)

Frees the resources allocated for a previously prepared query on the server and client sides.

UpdateResult (inherited from TMemDataSet)

Reads the status of the latest call to the ApplyUpdates method while cached updates are enabled.

UpdateStatus (inherited from TMemDataSet)

Indicates the current update status for the dataset when cached updates are enabled.

TMyServerControl Methods

Public

See Also